You can use this database file to maintain employee data such as hire date, salary, manager, department, pay grade, and next review date. You can also include personal information.
How to use this solution
Use the phone dialing feature to quickly dial the employee's extension. In an emergency, you can click the telephone icon next to the emergency contact information to call the contact person. You can edit your phone dialing preferences in the Preferences dialog box.
How to B
customize this solution
You can create a layout to print employee identification badges. You can also integrate this database with other databases, such as "Expense Reports" using lookups and relations.
Form View - Job
A List View
Employee Phone List
Information
Report Menu
A Home CityB
Home StateB
Home ZIP CodeB
NotesB
Phone\ExtensionB
Date CreatedB
Date ModifiedB
Social Security NumberB
X1Please enter a number in the form of 000-00-0000.
) = 11 )
GenderB
Date of BirthB
Date of HireB
Date of Next ReviewB
Home PhoneB
Employee TypeB
Employee PictureB
Emergency ContactB
Emergency PhoneB
InfoB
Created ByB
Last LayoutB
Form View - JobB
Form View - Personal
A List ViewB
Your Own
Buttons
Your Own
Buttont
Recordu
Delete
Recordv
Recordw
Reportsx
View As
Listy
View As
Formz
Close{
Info|
Type}
Social Security Number~
Date of Hire
Next Review
Salary
A Pay Grade
Manager
Phone/Ext.
Department
Title
F Last Name
First Name
H ID Number
Enter data for Employees
Notes
Personal
Information
Position
Employee
Employee Phone ListB
Phone\Ext.P
DepartmentQ
TitleR Last NameS
First NameT
Your Own
ButtonU
Your Own
ButtonV
RecordW
Delete
RecordX
RecordY
ReportsZ
View As
List[
View As
Form\
Close]
Info^-Click to see more information for an Employee
InformationB
Your Own
Buttonn
Reportso
View As
Listp
View As
Formq
Closer
Infos
Phonet
Departmentu
Titlev Last Namew
Page ##y
Employee Phone Listz
First Name
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO0Information about the Personnel Records solutionP
Info for this Solution
ut the Personnel Records solutionP
Info for this Solution
Your Own
ReportB
Your Own ReportC
Your Own ReportD
Employee Phone ListE
Your Own
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
Form View - PersonalB
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Your Own
Button{
Your Own
Button|
Record}
Delete
Record~
Record
Reports
View As
View As
Close
Phone
Emergency Contact
Gender
G Birthdate
Phone
ZIP Code
Address
Phone/Ext.
Department
Title
P Last Name
First Name
R ID Number
Personal
Information
Position
Enter data for Employees
Notes
Employee
DavidsonD
JulieE
125000G
Human ResourcesK
DirectorO
839 Eighth Ave.P
Foster CityQ
94401U
7393Y
10/19/95_
123-45-6789`
Femalea
05/01/62e
5/2/95f
6/1/95g
415-555-0900h Full Timei
Jack Davidsonk
408-555-2211
PamelaE
65000G
Human ResourcesH
Julie DavidsonK
ManagerO
466 West Ave.P
EckmanQ
24829U
7396Y
10/19/95_
111-23-9845`
Femalea
09/21/61e
5/18/93f
5/18/96g
712-555-5245h Full Timei
hj Peter Dayk
712-555-6357
LongD
JackE
32000G MarketingH
Dennis SmithK
Marketing SpecialistO
88 Liberty St.P
GrotonQ
01450U
3785Y
10/19/95_
456-66-9877`
Malea
3/15/65e
4/3/91f
4/3/96g
508-555-6899h Full Timei
Gertrude Longk
608-555-6513
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
TeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Dial Extension
Dial Home Phone
Dial Emergency Phone
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C)